#!/usr/bin/python3

prefix = "INSERT INTO Artist (Name, BirthDate) VALUES("
suffix = ");"
artistName = ""
artistBirthDate  = ""

data = open("flat_file.csv", "r")
output = open("parsedtables/populate_artist.sql", "w")

for line in data:
  fields = line.split(",")
  if(len(fields) > 1):
    output.write(prefix + str(fields[1]) + ", " + "NULL" + suffix + "\n")

data.close()
output.close()
